select `vehicles`.*, count(makes.id) as make_count, makes.make_name from `vehicles` inner join `body_style_groups` on `vehicles`.`body_style_group_id` = `body_style_groups`.`id` inner join `users` on `vehicles`.`user_id` = `users`.`id` inner join `makes` on `vehicles`.`make_id` = `makes`.`id` where (`vehicles`.`status_id` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR)) and `body_style_group_name` = ? and `users`.`name` = ? and `makes`.`make_name` != ? group by `makes`.`make_name` order by `make_count` desc
Array ( [0] => 1 [1] => SUV [2] => Leggat Stouffville Ford - new vehicles [3] => )
267.93
select `vehicles`.*, count(fuel_types.id) as fuel_count, fuel_types.fuel_type from `vehicles` inner join `body_style_groups` on `vehicles`.`body_style_group_id` = `body_style_groups`.`id` inner join `users` on `vehicles`.`user_id` = `users`.`id` inner join `fuel_types` on `vehicles`.`fuel_id` = `fuel_types`.`id` where (`vehicles`.`status_id` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR)) and `body_style_group_name` = ? and `users`.`name` = ? and `fuel_types`.`fuel_type` != ? group by `fuel_types`.`fuel_type` order by `fuel_count` desc
Array ( [0] => 1 [1] => SUV [2] => Leggat Stouffville Ford - new vehicles [3] => )
235.64
select *, (select count(*) from `vehicles` inner join `users` on `users`.`id` = `vehicles`.`user_id` where `provinces`.`id` = `users`.`province_id` and `vehicles`.`status_id` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR)) as `vehicles_count` from `provinces` order by `province_name` asc
Array ( [0] => 1 )
2723.72
select `makes`.* from `makes` inner join `vehicles` on `vehicles`.`make_id` = `makes`.`id` group by `makes`.`id`
Array ( )
663.82
select count(*) as aggregate from `vehicles` inner join `body_style_groups` on `vehicles`.`body_style_group_id` = `body_style_groups`.`id` inner join `users` on `vehicles`.`user_id` = `users`.`id` where (`vehicles`.`status_id` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR)) and `body_style_group_name` = ? and `users`.`name` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR)
Array ( [0] => 1 [1] => SUV [2] => Leggat Stouffville Ford - new vehicles )
227.41
select `vehicles`.* from `vehicles` inner join `body_style_groups` on `vehicles`.`body_style_group_id` = `body_style_groups`.`id` inner join `users` on `vehicles`.`user_id` = `users`.`id` where (`vehicles`.`status_id` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR)) and `body_style_group_name` = ? and `users`.`name` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR) order by `vehicles`.`created_at` desc limit 15 offset 0
Array ( [0] => 1 [1] => SUV [2] => Leggat Stouffville Ford - new vehicles )
236.68
select `vehicles`.* from `vehicles` inner join `body_style_groups` on `vehicles`.`body_style_group_id` = `body_style_groups`.`id` inner join `users` on `vehicles`.`user_id` = `users`.`id` where (`vehicles`.`status_id` = ? and `vehicles`.`created_at` > DATE_SUB(NOW(),INTERVAL 2 YEAR)) and `body_style_group_name` = ? and `users`.`name` = ? and (`users`.`featured` = ? or `vehicles`.`featured` = ?) order by RAND() limit 8
Array ( [0] => 1 [1] => SUV [2] => Leggat Stouffville Ford - new vehicles [3] => 1 [4] => 1 )
325.95
SUV Used Cars Preowned Vehicles
Filter

Quick Search

Close

SUV Used Cars Preowned Vehicles

Search

Filters Applied

  • dealer : Leggat Stouffville Ford - new vehicles
  • body : SUV

Select Province

Condition

Seller

Select Make

Select Fuel

Transmission

Filter by Price

$ — $

Filter by Odometer

Km — Km

Filter by Year

—

Sort By
Date
Price
Odometer
Year

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
24.76
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 253 )
3.7
Bronco - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
0.29
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
0.27
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.18
Ontario

Stouffville, Ontario

Added 1 week ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
0.3
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 9418 )
0.3
Velocity Blue Metallic | auto

Leggat Stouffville Ford - new vehicles

  • $78,900
  • 25KM

  • --

2025 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
8.11
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 267 )
3.73
Escape - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
2.4
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
0.26
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.19
Ontario

Stouffville, Ontario

Added 1 week ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
3.75
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 10003 )
3.87
Carbonized Grey Metallic | auto

Leggat Stouffville Ford - new vehicles

  • $50,694
  • 25KM

  • --

2025 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
0.21
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 267 )
0.2
Escape - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
0.23
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
0.17
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.17
Ontario

Stouffville, Ontario

Added 1 week ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
0.18
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 14962 )
5.04
Space Silver Metallic | auto

Leggat Stouffville Ford - new vehicles

  • $42,444
  • 25KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
0.27
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 253 )
0.2
Bronco - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
0.24
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
2.94
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.23
Ontario

Stouffville, Ontario

Added 1 week ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
0.18
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 41 )
0.2
| auto

Leggat Stouffville Ford - new vehicles

  • $64,225
  • 25KM

  • --

Sponsored Advertisement

Auto Loan Canada

100% credit acceptance

Easy 60-Second Application

APPLY NOW

2025 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
0.16
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 267 )
0.16
Escape - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
0.23
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
0.64
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.17
Ontario

Stouffville, Ontario

Added 2 weeks ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
0.29
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 14962 )
0.19
Space Silver Metallic | auto

Leggat Stouffville Ford - new vehicles

  • $39,244
  • 25KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
0.17
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 3083 )
2.48
Bronco Sport - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
0.24
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
0.17
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.17
Ontario

Stouffville, Ontario

Added 2 weeks ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
0.17
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 10003 )
0.16
Carbonized Grey Metallic | auto

Leggat Stouffville Ford - new vehicles

  • $44,370
  • 26KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
1.59
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 3149 )
0.17
Mustang Mach-E - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
0.23
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
0.26
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.17
Ontario

Stouffville, Ontario

Added 3 weeks ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
3.59
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 15558 )
3.89
Glacier Grey Metallic Tri-Coat | auto

Leggat Stouffville Ford - new vehicles

  • $71,385
  • 25KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
0.21
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 3083 )
0.2
Bronco Sport - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
0.24
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
6.66
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.22
Ontario

Stouffville, Ontario

Added 3 weeks ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
0.27
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 69 )
0.21
OXFORD WHITE | auto

Leggat Stouffville Ford - new vehicles

  • $44,370
  • 25KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
0.17
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 3083 )
0.17
Bronco Sport - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
0.23
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
0.17
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.16
Ontario

Stouffville, Ontario

Added 3 weeks ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
0.29
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 9467 )
0.19
CACTUS GREY | auto

Leggat Stouffville Ford - new vehicles

  • $44,370
  • 25KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
0.18
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 3083 )
0.17
Bronco Sport - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
2.13
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
0.19
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.17
Ontario

Stouffville, Ontario

Added 3 weeks ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
0.18
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 69 )
0.17
OXFORD WHITE | auto

Leggat Stouffville Ford - new vehicles

  • $55,875
  • 25KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
0.17
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 253 )
0.23
Bronco - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
0.23
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
0.17
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.16
Ontario

Stouffville, Ontario

Added 3 weeks ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
0.27
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 289 )
0.2
Shadow Black | auto

Leggat Stouffville Ford - new vehicles

  • $56,105
  • 25KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
0.17
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 3083 )
0.16
Bronco Sport - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
0.23
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
0.17
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.17
Ontario

Stouffville, Ontario

Added 3 weeks ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
3.86
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 15012 )
3.72
AZURE GREY METALLIC TRI-COAT | auto

Leggat Stouffville Ford - new vehicles

  • $43,785
  • 25KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
0.2
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 3083 )
0.3
Bronco Sport - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
0.23
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
0.17
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.25
Ontario

Stouffville, Ontario

Added 3 weeks ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
0.18
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 12052 )
9
ERUPTION GREEN METALLIC | auto

Leggat Stouffville Ford - new vehicles

  • $46,395
  • 25KM

  • --

2024 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
3.84
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 3083 )
0.21
Bronco Sport - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
0.29
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
0.18
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.18
Ontario

Stouffville, Ontario

Added 3 weeks ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
0.18
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 12193 )
0.17
Hot Pepper Red Metallic Tinted Clearcoat | auto

Leggat Stouffville Ford - new vehicles

  • $43,585
  • 25KM

  • --

2025 select * from `makes` where `makes`.`id` = ? limit 1
Array ( [0] => 17 )
0.2
Ford select * from `models` where `models`.`id` = ? limit 1
Array ( [0] => 267 )
0.16
Escape - select * from `users` where `users`.`id` = ? limit 1
Array ( [0] => 1898 )
16.75
select * from `cities` where `cities`.`id` = ? limit 1
Array ( [0] => 262 )
0.29
Stouffville, select * from `provinces` where `provinces`.`id` = ? limit 1
Array ( [0] => 6 )
0.19
Ontario

Stouffville, Ontario

Added 1 month ago

select * from `body_style_groups` where `body_style_groups`.`id` = ? limit 1
Array ( [0] => 5 )
0.2
SUV | select * from `colors` where `colors`.`id` = ? limit 1
Array ( [0] => 69 )
0.17
OXFORD WHITE | auto

Leggat Stouffville Ford - new vehicles

  • $37,044
  • 25KM

  • --

Sponsored Advertisement

Auto Loan Canada

100% credit acceptance

Easy 60-Second Application

APPLY NOW